Copy Paste Range
AutomatR.Excel.Activities.CopyPasteRange
The "Copy Paste Range" activity in AutomatR is part of the Excel activities package, facilitating the copying of an entire range, including values, formulas, table format, and cell format. The copied range can then be pasted to a specified sheet in an Excel workbook. This activity streamlines the process of transferring data and formatting within Excel, enhancing automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Destination Cell | Specifies the start cell for the range to be pasted. Enter the cell reference (e.g., "A1") where the top-left corner of the copied range should be pasted in the destination sheet. String variables containing the destination cell reference. |
| Source Range | Specifies the range to copy. Enter the range reference (e.g., "A1:B10") from the source sheet that should be copied. String variables containing the source range reference. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Copy Paste Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Copy Paste Range" activity onto the workflow.
- Configure the properties by specifying the source range and destination cell within the Excel workbook.
- Optionally, configure the delay.
- Execute the workflow to copy the specified range and paste it to the designated cell in the destination sheet.
Example: Consider an example where the "Copy Paste Range" activity is used to copy a range from "A1:B10" and paste it starting from cell "C1" in the same sheet:
Copy Paste Range:
Source Range: "A1:B10"
Destination Cell: "C1"
Delay: 2
In this example, the activity copies the range "A1:B10" and pastes it starting from cell "C1" with a 2-second delay, allowing time for any necessary cleanup or synchronization.